import pandas as pd
import os

path = 'C:/Users/pc/Desktop/产品研发情况分析/'

df_Feature = pd.read_csv(
    'C:/Users/pc/Desktop/产品研发情况分析/【绝密】业务三部目标管理_需求管理表_汽车数字化需求管理表.csv')
df_Task = pd.read_csv(
    'C:/Users/pc/Desktop/产品研发情况分析/【绝密】业务三部目标管理_需求管理表-任务执行表_任务执行表.csv')
df_Epic = pd.read_csv(
    'C:/Users/pc/Desktop/产品研发情况分析/【绝密】业务三部目标管理_原始需求策划-产品规划_原始需求表.csv')

df = pd.merge(left=df_Epic[["原始需求ID", "模块", "一级", "二级", "三级"]],
              right=df_Feature[["原始需求ID", "一级", "二级", "三级"]], on='原始需求ID', how='left')
print(df)
